package com.stylefeng.guns.common.persistence.dao;

import com.stylefeng.guns.common.persistence.model.ContestPoints;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
  *  Mapper 接口
 * </p>
 *
 * @author jondai
 * @since 2018-01-11
 */
public interface ContestPointsMapper extends BaseMapper<ContestPoints> {
    /**
     * 根据员工编号年度查询总积分
     * @param item
     * @param year
     * @return
     */
    Double sumIntegralInEmpCode(@Param("item") List<String> item,@Param("year") String year);
    /**
     * 根据员工编号年度查询积分
     * @param item
     * @param year
     * @return
     */
    List<ContestPoints> selectInEmpCode(@Param("item") List<String> item,@Param("year") String year);
}